package com.example.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.vo.IdxInfoVO;
import com.example.vo.TableDDLVO;
import com.example.vo.TableInfoVO;
import com.example.vo.TableVO;
import com.example.entity.UserTables;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface CommonMapper extends BaseMapper<UserTables> {

//    @Select("select t.table_name tableName, f.comments comments\n" +
//            "  from user_tables t\n" +
//            " inner join user_tab_comments f\n" +
//            "    on t.table_name = f.table_name")
    List<TableVO> queryTableNameList();

    List<TableDDLVO> getDDL(@Param("tableName") String tableName);

    List<TableInfoVO> getTableInfo(@Param("tableName") String tableName);

    List<IdxInfoVO> getIdxInfo(@Param("tableName") String tableName);
}
